Devin Lee
Devin Lee
Reactions
-
Re: Formula to check a box if the date in another column is the current month
=IF(MONTH(Created@row) = MONTH(TODAY()), 1, 0)2 · -
Re: Simple time tracking per task for multiple assignees
Hey @Mike Tomei How about a time log trigger that copies the row into another sheet that we can then pull from to get total hours? To record that information you need to add three columns [Name], [Ti…1 · -
Re: What is the formula to flag duplicates from a multi-select drop down column?
Hey @sambittner, You can make a list of all the available times, set the sheet to public, and create an automation that locks the row once someone has entered their name into the time slot. You could…1 · -
Re: Formula to check box when a drop down has been selected AND it is a row of indent level above 1
Hey @Katie F, Try something like this. =IF(AND([Consultant Assessment]@row <> "", [Indent Level]@row > 2), 1, 0)1 · -
Re: Unparseable error with "IF"
Hey @Yahaira Paredes Smartsheet doesn't operate with % symbols in formulas. Percent is only a format for the time being. The formula below should work for you. =IF([2021]@row / [2020]@row - 1 > 1,…1 ·
